Edit an exported Unicode text file in Excel
You can edit an exported Unicode text file in Microsoft Excel (recommended).
To edit an exported Unicode text file in Excel
- Open Excel, and from the File menu, select Open.
- In the Open dialog box, make sure that All Files is selected, select the file you are going to edit, and click Open. The Text Import Wizard opens.
- In Step 1 of the Text Import Wizard, select the following options and click Next:
- Choose the file type that best describes your data: Delimited
- Start import at row: 1
- File origin: Windows (ANSI)
- In Step 2, select the following options and click Next:
-
Delimiters the data must contain: Tab (make sure the other check boxes are cleared.)
-
Treat consecutive delimiters as one: clear the check box
- In Step 3, for Column data format, select General.
- Click Finish.
The first seven lines of the Unicode file explain what you can and cannot change in the file.
See also
Prepare an application for language switching
Language Configuration dialog box
Export text strings to a Unicode text file
Save the edited Unicode text file in Excel
Edit an exported Unicode text file in Notepad